Release 10.1A: OpenEdge Data Management:
SQL Reference

SET PRO_CONNECT LOG

Controls logging for the current SQL Server connection.

Syntax

SET PRO_CONNECT LOG [ ON | OFF ] [ WITH STATEMENT ];

ON

Indicates that logging is turned on.

OFF

Indicates that logging is turned off.

STATEMENT

Indicates that statement tracing information is written to the log file.

Notes

When logging is set ON, the current SQL connection begins logging to a file named as follows:

SQL_server_<server-id>_<ddmmmyyyy>_<hhmmss>.log

For example: SQL_server_1_05MAY2005_112609.log

The server-id corresponds to the server ID shown in database_name.lg.
Logging files are located in the server’s work directory. The work directory corresponds to the value of the WRKDIR environment variable on UNIX systems and the applicable registry settings in Windows systems.
The maximum size of each logging file is 500 MB. When SQL_server_<server-id>_<ddmmmyyyy>_<hhmmss>.log reaches 500 MB, the server logs a message indicating the file was closed due to reaching the maximum size. After this message is written, all logging stops, logging is set to the OFF state, and SQL_server_<server-id>_<ddmmmyyyy>_<hhmmss>.log automatically closes.
When logging commences to a new file, the file contents begin with information about the SQL Server environment, including:
Environment variable settings.
Parameter values passed to the server at startup.
Logging control values (such as size limits).
The SQL Server process ID.
Each section of information written to the log file begins with the following string:

DDMMMYYYY HH:MM:SS <user-id>:

For example, 19AUG2005 12:00:00 1: